# -*- coding:utf-8 -*-


class ResourceManageSql(object):
    """用户管理相关SQL"""

    # 人力资源管理列表
    RECOURSE_LIST = "SELECT applicant_name, station, tel, preliminary_result, reexamination_result," \
                    "final_result, appointment FROM resourcesmanage "

    # 新增人力
    ADD_RECOURSE = "INSERT INTO resourcesmanage(applicant_name, station, tel, preliminary_result, " \
                   "preliminary_opinion, reexamination_result, reexamination_opinion, final_result, " \
                   "final_opinion, appointment) " \
                   "VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)returning id"

    # 编辑人力
    EDIT_RECOURSE = "UPDATE resourcesmanage SET applicant_name = %s, station = %s, tel = %s, preliminary_result = %s," \
                    "preliminary_opinion = %s, reexamination_result = %s, reexamination_opinion = %s, " \
                    "final_result = %s, final_opinion = %s, appointment = %s " \
                    "WHERE id = %s"

    # 删除人力
    DEL_RECOURSE = "DELETE FROM resourcesmanage WHERE id=%s"
    
    